package com.tust.dao;

import com.tust.domain.Grade;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface GradeDao {
    int insertGrade(Grade grade);
    int deleteGrade(Grade grade);
    int updateGrade(@Param("oldGrade") Grade oldGrade, @Param("grade") Grade grade);
    List<Grade> selectGrade(Grade grade);
    List<Grade> selectGradeByStudentNum(@Param("studentNum") String studentNum);
    List<Grade> selectGradeByCourseNum(@Param("courseNum") String courseNum);
    List<Grade> selectGradeByExamTimes(@Param("examTimes") String examTimes);
    List<Grade> selectGradeByRegularGrade(@Param("regularGrade") String regularGrade);
    List<Grade> selectGradeByExamGrade(@Param("examGrade") String examGrade);
    List<Grade> selectGradeByTotalGrade(@Param("totalGrade") String totalGrade);
    List<Grade> selectGradeAll();
}
